Installation Note 38046: An error occurs when you try to connect to a Greenplum database via SAS/ACCESS® Interface to Greenplum
 |  |  |  |  |
Without the DataDirect ODBC Driver for Greenplum, you cannot connect to Greenplum databases by using SAS/ACCESS Interface to Greenplum. In the second and thrid maintenance release for SAS 9.2 (TS2M2 and TS2M3), that driver is not available when you install and configure SAS/ACCESS Interface to Greenplum. As such, if you try to connect to a Greenplum database after you install SAS/ACCESS Interface to Greenplum, you will receive an error message similar to the following:
ERROR: The SAS/ACCESS Interface to GREENPL cannot be loaded. The SASGPL code appendage could not be loaded. ERROR: Error in the LIBNAME statement.
Click the Hot Fix tab in this note to access the hot fix which supplies the DataDirect ODBC Driver for Greenplum.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Greenplum | Solaris for x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Linux for x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Linux | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| HP-UX IPF | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 | ||
A fix for this issue for SAS/ACCESS Interface to Greenplum 9.21 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A77.html#38046A fix for this issue for SAS/ACCESS Interface to Greenplum 9.21_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B92.html#38046| Type: | Installation Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> GreenPlum |
| Date Modified: | 2010-03-08 15:34:15 |
| Date Created: | 2009-12-04 16:14:47 |